import sqlalchemy
from sqlalchemy.orm import Mapped,mapped_column
from settings.publicvar import Base

class CreateSchoolInfo(Base):
    __tablename__ = 'schoolinfo'

    id:Mapped[int] = mapped_column(primary_key=True)
    name:Mapped[str] = mapped_column(sqlalchemy.String(20))
    schoolid:Mapped[str] = mapped_column(sqlalchemy.String(20))
    maker:Mapped[str] = mapped_column(sqlalchemy.String(150))

    def __repr__(self):
        return f'name:{self.name}'

